Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
48 1Z0-447 You need to manually patch Oracle GoldenGate source and targets. How should you proceed? Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. If the patches changed table definitions, run DEFGEN for the source tables to generate updated source definitions, and then replace the old definitions with the new ones in the existing source definitions file on the target system. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source and on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again. Stop access to the source and target databases. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again. Stop access to the source and target databases. Start applying the patch on the source. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again. 1 SC edit delete
47 1Z0-447 What sequence of steps should you follow to add a data pump that reads from a local trail? In GGSCI, on the source system, issue the command: ADD EXTRACT group name, TRAILSOURCE trail name. In GGSCI, on the source system, issue the command: ADD PUMP group name, TRAILSOURCE trail name. In GGSCI, on the source system, issue the command: ADD PUMP group name, EXTTRAILSOURCE trail name. In GGSCI, on the source system, issue the command: ADD EXTRACT group name, EXTTRAILSOURCE trail name. 4 SC edit delete
46 1Z0-447 Which Replicat MAP parameter and syntax should be used to detect an update conflict on the EURO.SEAT_RESV table and resolve the conflict by determining which record has the oldest LAST_UDATE value? MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMIN (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COMPARECOLS (ON UPDATE KEYINCLUDING (last_update)), RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMIN (last_update))); MAP us.seat_resv, TARGET euro.seat_resv, COMPARECOLS (ON INSERT KEYINCLUDING (last_update)), RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, USEDELTA (last_update))); 3 SC edit delete
45 1Z0-447 An integrated Replicat is running with PARALLELISM set to four, yet you discover that for a series of large operations, only one apply server is processing the operations. What is the reason for this issue? Operations are grouped into one apply server automatically based on GROUPTRANSOPS. Parallelism for an Integrated Replicat cannot exceed one. The operations for a particular table are pinned to a specific apply server. The operations are all part of one transaction. 1 SC edit delete
44 1Z0-447 Which option is not included as part of a Veridata installation? Veridata BackPlane Server Veridata Agent Veridata Web Server Veridata Repository 1 SC edit delete
43 1Z0-447 You must prepare the source database to send redo to the mining database. What sequence of steps should you follow to accomplish this? Ensure that the source database is running with the required compatibility. Use the TRANSLOGOPTIONS parameter, set up redo transport at the source database, and enable the downstream destination. Ensure that the source database is running with the required compatibility. Set DB_CONFIG at the source database. Set up redo transport at the source database. Set DG_CONFIG at the source database and enable the downstream destination. Ensure that the source database is running with the required compatibility. Set DG_CONFIG at the source database. Set up redo transport at the source database and enable the downstream destination. 4 SC edit delete
42 1Z0-447 In which process should you configure the warning for long-running transactions? Jagent Extract Replicat Manager 2 SC edit delete
41 1Z0-447 Which two are valid macros? A B C D 41-Aggans.png 41-Bggans.png 41-Cggans.png 41-Dggans.png 1, 4 MC edit delete
40 1Z0-447 Which method in GoldenGate should you use to undo DML changes previously made to a target database? Run Extract and Replicat from the command line. Use Extract and Replicat with the GoldenGate Logdump utility. Run the Reverse Utility on the target database transaction logs. Use Extract and Replicat with the GoldenGate Reverse utility. 4 SC edit delete
39 1Z0-447 You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running? Start the Extract task. Start the Extract task, wait for it to stop, and then start the Replicat task. Start the Extract task and then start the Replicat task. Start the Replicat task. 3 SC edit delete
38 1Z0-447 You want to eliminate the reporting output from processing a Macro. How should you proceed? Use the optional parameter NOLIST. Use the optional parameter UNLIST. Use the optional parameter NOREPORT. Use the optional parameter NOMACROOUTPUT. 1 SC edit delete
37 1Z0-447 Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger? Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater 3 SC edit delete
36 1Z0-447 Which GLOBALS parameter is required to initially enable monitoring? JAGENTMONITORING ENABLEMONITORING ENABLEOEMMONITORING CHECKMONITORING 2 SC edit delete
35 1Z0-447 You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services? Create a GLOBALS file for each installation and use the MGRSERVNAME parameter, with a unique name. Include the parameter SERVICENAME in each Manager, with a unique name. Accept the default service name and manually edit within the Services applet. Multiple Manager services are not allowed on the same Windows server. 1 SC edit delete
34 1Z0-447 Select four Oracle GoldenGate use cases. real-time discovery real-time data warehousing offload reporting zero downtime upgrades and migrations backup and recovery data center load balancing by using multi-master replication 2, 3, 4, 6 MC edit delete
33 1Z0-447 For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management? Teradata Informix Sybase DB2 4 SC edit delete
32 1Z0-447 You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT <extractgroup> SHOWCH. How should you proceed? Use the Read Startup Checkpoint. Use the Read Recovery Checkpoint. Use the Write Startup Checkpoint. Use the Read Current Checkpoint. 2 SC edit delete
31 1Z0-447 Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this? View the maybe out-of-sync (MOOS) queue. View the Veridata log file. View the confirm-out-of-sync (COOS) queue. View the Veridata Agent repository. 1 SC edit delete
30 1Z0-447 Which Logdump command is used to check how many change records are in the trail file? STATS REPORT REPORTCOUNT COUNT 4 SC edit delete
29 1Z0-447 Which parameter for GoldenGate 12c enables DDL replication for a Replicat? TARGETDDL GETDDL DDL for Replicat is enabled by default. USEDDL 3 SC edit delete
28 1Z0-447 Which three are valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column? (Select three.) MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID)); MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID)); TABLE fin.Sales, FILTER (@RANGE (1, 2)); FILTER (@RANGE (2, 2, AccountID)); FILTER (@RANGE 2, 2, ID); 1, 2, 3 MC edit delete
27 1Z0-447 You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In. When you start JAgent, it fails with “ajava.lang.Exception: One or more Java Agent properties in Config.properties are not defined properly”. What is the first thing to check? if The Enterprise Manager Agent is running if the JAgent has been enabled in the GoldenGate Manager if the agent type is set to OEM in JAgent properties if the Oracle Wallet has been created for the JAgent 3 SC edit delete
26 1Z0-447 You must synchronize tables with Large Object data types. Which Initial Load method supports this process? File to Replicat GoldenGate Direct Load File to database utility Direct bulk load to SQL*Loader 4 SC edit delete
25 1Z0-447 You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts. How should you accomplish this? Use the COMPCOLS with the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause. Use the COMPARECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause. Use the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause. Use the GETBEFORECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause. 2 SC edit delete
24 1Z0-447 Identify two correct statements regarding GoldenGate supported features. GoldenGate supports network encryption and compression. GoldenGate supports DML and DDL replication for all supported databases. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source. 1, 3 MC edit delete
23 1Z0-447 Which statement regarding the GoldenGate Data Pump is incorrect? Data Pump is a separate process. Data Pump can be used to pump trail records to multiple locations. Data Pump has distance limitations. Data Pump uses TCP/IP to route the trail records. 1 SC edit delete
22 1Z0-447 How should you configure Replicat to control how errors are handled in one-way replication? Use REPERROR in the Replicat parameter file. Use HANDLECOLLISION in the Replicat parameter file. Use Conflict Detection and Resolution in the Replicat parameter file. Use MAPEXCEPTION in the Replicat parameter file. 1 SC edit delete
21 1Z0-447 Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate? ENABLE_GOLDENGATE_REPLICATION=true ENABLE_STREAMS_REPLICATION=true Configure the STREAMS_POOL_SIZE database parameter ENABLE_DATABASE_REPLICATION=true 1 SC edit delete
20 1Z0-447 Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after Extract has stopped? Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility. Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility. Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility. Use the PURGEORPHANEDTRANSACTIONS parameter to control the bounded recovery feature of the general Extract checkpointing facility. 3 SC edit delete
19 1Z0-447 You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to–database utility. How should you configure GoldenGate in order to accomplish this? Configure Replicat with the FORMATASCII SQLLOADER OPTION. Configure Extract with the FORMATSQL SQLLOADER OPTION. Configure Extract with the FORMATASCII SQLLOADER OPTION. Configure Replicat with the FORMATXML OPTION. 3 SC edit delete
18 1Z0-447 Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables. Run the chkpt_db_extracttrail.sql script. Run the chkpt_db_create.sql script. Use the ADD Extract Trail command. Use the INFO REPLICAT command with the SHOWCH option. Use the ADD CHECKPOINTTABLE command. 3, 5 MC edit delete
17 1Z0-447 Identify the correct statement regarding Trails. Extract and Pump are different OS level executable binary files. Extracts cannot perform filtering, mapping, and transformations. RMTTRAIL is for remote trails and EXTTRAIL is for local trails. Extract is typically used to produce local trail files over a TCP/IP connection. 2 SC edit delete
16 1Z0-447 Which statement is valid for DDL replication? GoldenGate User Exits are not supported for DDL. Source and target objects can be different. Target objects can be different from source when using SOURCEDEFS in Replicat. It can use WILDCARDRESOLVE IMMEDIATE. 2 SC edit delete
15 1Z0-447 What software is required prior to running Oracle GoldenGate in a Windows Server environment? Oracle Gateway software configured for that particular database platform JDBC drivers into the GoldenGate home directory Microsoft Visual C++ 2010 SP1 Redistributable Package Nothing, configure GoldenGate Jagent for that particular database platform. 3 SC edit delete
14 1Z0-447 What is the function of the GoldenGate JAgent? It performs connections via JDBC to run the Veridata comparisons. It enables communication between GoldenGate and Monitor, and Enterprise Manager Agent. It reads the database transaction logs. It integrates GoldenGate with Oracle Data Integrator. 2 SC edit delete
13 1Z0-447 Your GoldenGate deployment is using a shared wallet, and older versions of the master key should be retained after the master key is renewed until all processes are using the newest version. How should you determine whether all of the processes are using the newest version so that you can delete older versions of the master key? GoldenGate deployments cannot use a shared wallet. View the GoldenGate log files to monitor Replicat report files to verify that the SCN was applied by all Replicat groups. View the report file of the newest Extract after renewing the master key to confirm the last SCN that was mined with old key. View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old key. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups. 4 SC edit delete
12 1Z0-447 You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to? It is caused by THREAD and THREADRANGE being used with wildcard MAP statements. It is caused by the thread with the highest thread ID applying barrier transactions. It is caused by the use of the MAXTRANSOPS parameter. It is caused by barrier transactions in a Coordinated Replicat. 4 SC edit delete
11 1Z0-447 You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this? Use the command option AFTERCSN. Use the command option ATCSN. Use the command option UNTIL CANCEL. Use the command option RESUME. 1 SC edit delete
10 1Z0-447 When is a Pump not required to connect to a source database? when transformations, filtering, and mapping are required when look-ups are needed against the source database when a PASSTHRU parameter is used when a NOPASSTHRU parameter is used 2 SC edit delete
9 1Z0-447 You want to use multiple concurrent Extract process groups. What is the key factor in determining how many can be running at the same time? the number of concurrent users disk space system memory the number of compound keys on the source tables 3 SC edit delete
8 1Z0-447 You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used? Oracle Goldengate for Big Data Oracle Goldengate Application Adapters Oracle Goldengate Veridata Oracle Data Integrator Adapters 2 SC edit delete
7 1Z0-447 You must return column-level detail for out-of-sync rows. How can you accomplish this? The Oracle GoldenGate Veridata Agent executes database-related requests on behalf of the Oracle GoldenGate Veridata Server. The Oracle GoldenGate Veridata Manager executes auto-memory database-related requests on behalf of the Oracle GoldenGate Veridata Server. The Oracle GoldenGate Veridata Agent source database executes database-related requests on behalf of the Oracle GoldenGate Veridata Server. The Oracle GoldenGate Veridata Manager executes database-related requests on behalf of the Oracle GoldenGate Veridata Server. 1 SC edit delete
6 1Z0-447 You want to monitor replication not only to check that the processes are running, but to specifically verify that the data continuously replicates. How should you accomplish this? Implement GoldenGate Monitor. Have the customer continuously update the application data. Monitor the GoldenGate lag and last checkpoint time statistics. Implement heartbeat tables for replication. 3 SC edit delete
5 1Z0-447 Which command provides statistics about GoldenGate processes and memory resource utilization? SEND…CACHEMGR SEND…LOGSTATS SEND…GETTCPSTATS INFO…SHOWCH 1 SC edit delete
4 1Z0-447 You want to issue GoldenGate commands from a script. What sequence of steps should you follow to accomplish this? Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI ./ input_file, where the file name is the script file. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci < input_file from the command line of the operating system, where the input_file is an OBAY text file. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI < input_file, where the file name is an OBEY file. Create a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci ./ input_file from the command line of the operating system, where the file name is the script file. 2 SC edit delete
3 1Z0-447 Which three are the responsibility of the MGR process? (Select three.) Process management Trail File management Data movement Receive or route requests from the UI Trigger execution 1, 2, 3 MC edit delete
2 1Z0-447 You edit the GLOBALS file, save the changes, and restart GGSCI to have the change take effect. However, when you try to start the Manager, it fails. Which action should solve the problem? Use the CLEANUP REPLICAT command. Use a text editor to check the GLOBALS file for syntax errors and correct them. Verify that Oracle environment variables are set correctly. Add the Oracle GoldenGate Installation directory to the system PATH. 3 SC edit delete
1 1Z0-447 You must locate the next good record header in a Logdump file. How should you do this? Logdump > SCANFORGHDR Logdump > GHDR ON Logdump > SCANFORENDTRANS Logdump > SCANFORHEADER 4 SC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018